Search - sql excel

[ADO-ODBC] SQL Server与Access、Excel的数据转换

Description: SQL Server与Access、Excel的数据转换-SQL Server and Access, Excel data conversion
Platform: | Size: 2339 | Author: 徐剑 | Hits:

[ADO-ODBC] SQL SERVER与ACCESS、EXCEL数据转换

Description: This a p熟悉SQL SERVER 2000的数据库管理员都知道，其DTS可以进行数据的导入导出，其实，我们也可以使用Transact-SQL语句进行导入导出操作。在 Transact-SQL语句中，我们主要使用OpenDataSource函数、OPENROWSET 函数，关于函数的详细说明，请参考SQL联机帮助。利用下述方法，可以十分容易地实现SQL SERVER、ACCESS、EXCEL数据转换，hoto of a general purpose timer/counter card you can wirewrap in a weekend. It plugs into your PC s ISA bus just like a sound or modem card. It gives high-resolution timing (microseconds). Because of its programmablity, it is very powerful and flexible. You can even control DC or servo motors using pulse-width modulated (PWM), or stepper motors using its square wave capabilities. The figure below is the actual output (square wave) from the 8254 card captured by an oscilloscope: -This a p familiar with the SQL Server 2000 database administrators know, the DTS can import data is derived, in fact, we can also use Transact-SQL for importing and exporting operation. The Transact-SQL statements, we mainly use OpenDataSource function, OPENROWSET function, the function of the details, please refer to SQL online help. Use the following method, it is easy to SQL Server, Access, Excel data conversion, HOTO of a general purpose timer / counter card you can wirewrap in a weekend. It plugs into your PC ISA bus s just like a sound card or modem. It gives high-resolution timing (microseconds). Because of its programmablity, it is very powerful and flexible. You can even control or DC servo motors using pulse-width modulated (PWM), or Stepper motors using its square wave capabi
Platform: | Size: 5788 | Author: 海应 | Hits:

[Other Databases] Final CDMA

Description: 利用OLEDB以数据库的方式打开Excell文件，SQL语句同样适用-using OLEDB databases to open Excel documents, SQL statements apply equally
Platform: | Size: 1445888 | Author: 周云鹏 | Hits:

[Other Databases] pb_excel

Description: PB的数据窗口中的内容经常要导出为excel,自带的函数效果总是不好,可以试试这个,表头也可导出.-PB data window to the often exported to excel, and built-in function is undesirable results, you can try this, the first table can be derived.
Platform: | Size: 13312 | Author: 张一 | Hits:

[ADO-ODBC] 多种数据库快速访问

Description: 1、上载文件说明:通过IIS中将TEST.ASP文件置为主页，然后就可在浏览器中访问（本机IP或者输入127.0.0.1) 2、使用说明：用记事本打开TEST.ASP，其中包含对SQL、ORADLE、ACCESS、ODBC数据源、EXCEL和TXT文本数据库的访问代码，对应去掉注释符号，并修改默认数据库名称和访问密码，保存并打开浏览器即可将访问到的数据显示出来。相当方便，提供数据库访问的代码，很难得的东东哦！-1, to upload files Description: through IIS test.asp document will buy for the home page, and then you can visit in your browser (local IP or enter 127.0.0.1) 2, for use: use Notepad to open TEST.ASP, which includes SQL, ORADLE, ACCESS, ODBC data source, EXCEL and TXT text database access code, corresponding to the Notes to remove symbols, and modify the default database name and access password, save and open the browser can access the data will be displayed . Very convenient, to provide database access code, it is difficult to get Dongdong Oh!
Platform: | Size: 27648 | Author: 宝柱 | Hits:

[Other resource] ParseSql

Description: 解析Oracle的sql建表脚本的一个源程序，可以用于检查建表脚本，将表结构以格式化的方式显示，便于输入Excel-analytic Oracle sql script built Table 1 source can be used to check built Table script, table structure formatted in a manner that facilitate the importation of Excel
Platform: | Size: 20480 | Author: 郑泽洲 | Hits:

[JSP/Java] excel

Description: excel类封装了jxl的一些常用操作，只需调用excel的相关方法即可。-excel class encapsulates a number of commonly used jxl operation, simply call the relevant methods can excel.
Platform: | Size: 6144 | Author: 王泽虎 | Hits:

[Database system] ExcelToSql

Description: Excel转换导入进SqlServer数据库例程-Excel convert SqlServer database to import into the routine
Platform: | Size: 882688 | Author: 雨男 | Hits:

[Delphi VCL] SuperDBConverter

Description: 不同数据库的转换用delphi实现access excel sql server 等数据库的转换-Use different database delphi implementation of the conversion access excel sql server database, such as conversion
Platform: | Size: 605184 | Author: huankewen | Hits:

[Windows Develop] wincc-opc-excel

Description: OPC客户端访问WINCC OPC客户端访问WINCC 此方法实现比较简单，只要根据提供的名子 -OPC客户端访问WINCC 此方法实现比较简单，只要根据提供的名子 ...
Platform: | Size: 312320 | Author: qwe | Hits:

[ADO-ODBC] Discover

Description: 一个相对很完善的数据挖掘系统（少部分功能欠缺），不仅包括了按类Association（内含Apriori，C4.5，GrowTree）,Classification(ID3),Cluster划分常用的算法及个人优化后的算法。同时包含了多种数据源（MS Access，Excel，SQL Server，TEXT）的界面直接连接方式。界面方面更像一个专业的系统，采用了类VC浮动多框架界面，也可以作为界面编程的参考。这个工程的分数和其他小工具的分数一样，感觉亏大了:)-A relatively well-developed data mining system (a small number of features are not available), including not only the per-class Association (containing Apriori, C4.5, GrowTree), Classification (ID3), Cluster algorithm for division of common and individual optimized algorithms. Also includes a variety of data sources (MS Access, Excel, SQL Server, TEXT) means direct connection interface. Interfaces more like a professional system that uses a type of floating multi-frame interface, VC can also be programmed as an interface reference. The project scores and scores of other small tools, like, sensory loss big:)
Platform: | Size: 572416 | Author: 马志强 | Hits:

[CSharp] ExportExcel

Description: VS2005+SQL server2005 实现服务器端dbf txt excel的生成-VS2005+SQL server2005 execute dbf/txt/excel files creating on server
Platform: | Size: 141312 | Author: 肖亮 | Hits:

[.net] SQLServerToExcel

Description: MS-SQL Excel Upload Program
Platform: | Size: 22528 | Author: chinagold | Hits:

[.net] EXCEL

Description: EXCEL数据导入到SQL中，WEB版本的。原来是开发导入到ERP中生成订单使用的-NO
Platform: | Size: 649216 | Author: lvhongyue | Hits:

[SQL Server] SQL-import-command

Description: 一个sql导出命令大全，可以导出到excel，文本，dbf，acce-Sql command to export a Guinness, can be exported to excel, text, dbf, access
Platform: | Size: 3072 | Author: 黄伟 | Hits:

[SQL Server] Labview-Sql-Toolkit-Labview

Description: Labview Sql Toolkit 读研的时候，研究所老师花钱买的外面下不到需要的童鞋们有福了-The SQL Toolkit allows users to access and update databases from LabVIEW. LabVIEW interacts with a database through a database driver- the toolkit ships with drivers for many databases such as dBASE and FoxPro. A user is not limited to using the drivers that ship with the SQL Toolkit. For instance, if they already have Excel, they should configure their database to use the Microsoft supplied Excel driver. The SQL Toolkit establishes a database connection based upon information stored in the ODBC Administrator. ODBC is a database standard that specifies connectivity between database vendors. The ODBC Administrator is a Microsoft Utility that ships with the SQL Toolkit. It is also installed with other Microsoft Programs such as Excel or Access. The ODBC Administrator keeps track of databases through their DSN- data source name. Additional connection parameters (user name and password) and database attributes such as file cache size and locking can be specified in the ODBC Administrator a
Platform: | Size: 3339264 | Author: ganard | Hits:

Category

Source Code

Web/Internet

Develop Tools

Document

Other

Search in results

OS

Platform

Language

File Type

Search list